SELECT ORG_MEMBER.CODE psncode,FIELD0004 proname,FIELD0005 procode,"TO_CHAR"(FIELD0007,'yyyy-mm-dd hh:mm:ss') begintime,
"TO_CHAR"(FIELD0008,'yyyy-mm-dd hh:mm:ss') endtime,mpsn.CODE mpsncode FROM FORMMAIN_2056 
LEFT JOIN ORG_MEMBER ON ORG_MEMBER."ID" = FORMMAIN_2056.FIELD0001
LEFT JOIN ORG_MEMBER mpsn ON mpsn."ID" = FORMMAIN_2056.FIELD0011
WHERE ORG_MEMBER.CODE IS NOT NULL AND FIELD0004 IS NOT NULL AND 
FIELD0005 IS NOT NULL AND FIELD0007 IS NOT NULL AND FIELD0008 IS NOT NULL